# Supported data types

The table below shows the default mappings from Qlik Replicate data types to JSON and Avro logical data types.

For information on source data type mappings, see the section for the source endpoint you are using.

For additional information about Qlik Replicate data types, see [Replicate data types](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Endpoints/att_rep_data_types.htm).

[](https://help.qlik.com/en-US/replicate/Content/Replicate/Main/Confluent%20Cloud/confluent-data-types.htm)

## Mapping to JSON and Avro

Avro message format uses logical types for a more precise representation of the data type.

Data type mappings

| Qlik Replicate Data Types | JSON | Avro |
| --- | --- | --- |
| DATE | STRING | DATE<br><br>Annotates an Avro INT. |
| TIME | STRING | TIME-MILLIS<br><br>Annotates an Avro INT. |
| TIMESTAMP | STRING | TIMESTAMP-MICROS<br><br>Annotates an Avro LONG. |
| STRING | STRING | STRING |
| WSTRING | STRING | STRING |
| CLOB | STRING | STRING |
| NCLOB | STRING | STRING |
| NUMERIC | STRING | DECIMAL (p,s)<br><br>Annotates an Avro BYTES. |
| BYTES | STRING<br>(represented as hexadecimal digits) | BYTES |
| BLOB | STRING<br>(represented as hexadecimal digits) | BYTES |
| REAL4 | NUMBER | FLOAT |
| REAL8 | NUMBER | DOUBLE |
| INT1 | NUMBER | INT |
| INT2 | NUMBER | INT |
| INT4 | NUMBER | INT |
| INT8 | NUMBER | LONG |
| UINT1 | NUMBER | INT |
| UINT2 | NUMBER | INT |
| UINT4 | NUMBER | LONG |
| UINT8 | STRING | DECIMAL (20,0)<br><br>Annotates an Avro BYTES. |
| BOOLEAN | BOOLEAN | BOOLEAN |